{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["RATF","TOOL","."],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RATF","index":0,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,1,4],[9,1,9,2],[9,3,9,4],[4,3,5,4],[2,1,3,4],[7,3,8,4],[6,1,6,2],[6,3,6,4],[7,1,8,2],[4,1,5,2],[7,0,8,0],[2,0,3,0],[4,0,5,0],[34,1,35,2],[13,5,14,5],[15,5,16,5],[17,5,18,5],[19,5,20,5],[21,5,22,5],[23,5,24,5],[23,3,24,4],[13,3,14,4],[15,3,16,4],[17,3,18,4],[19,3,20,4],[21,3,22,4],[13,1,14,2],[15,1,16,2],[17,1,18,2],[10,5,11,5],[8,5,9,5],[31,1,32,2],[25,0,25,4],[31,0,32,0],[12,1,12,2],[12,3,12,4],[10,3,11,4],[10,1,11,2],[19,1,20,2],[21,1,22,2],[23,1,24,2],[10,0,11,0],[41,1,42,2],[40,1,40,2],[49,1,50,2],[49,0,50,0],[38,0,39,2],[47,0,48,2],[43,0,44,0],[41,0,42,0],[45,1,45,2],[43,1,44,2]]}
["REIMBURSEMENT AFTER THE FACT  -  FRAMES"]
[]
["VSP PLAN TYPE"]
[]
["ORDER DISCOUNTS",0.1,null,0.2]
[]
[null,"ORIGINAL UNIT PRICE",null,"VSP ALLOWANCE"]
["FRAME"]
[]
[null,"ORIGINAL UNIT PRICE",null,"VSP MATERIAL COPAY"]
["BASE LENS",null,null,null,null,{"$f":"IF(A11=\"BASE LENS\",\"\",A11)","v":""}]
[]
["LENS ENHANCEMENTS","ORIGINAL UNIT PRICE",null,"LE COPAY",null,"LE CHART"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Retail Cost","With Benefits","Reimbursement"]
[{"$f":"TOOL!B20","v":"Lenses"},{"$f":"TOOL!C20","v":0},{"$f":"TOOL!D20","v":0},{"$f":"TOOL!E20","v":0}]
[{"$f":"TOOL!B21","v":"Frame"},{"$f":"TOOL!C21","v":0},{"$f":"TOOL!D21","v":0},{"$f":"TOOL!E21","v":0}]
[{"$f":"TOOL!B22","v":"Total"},{"$f":"TOOL!C22","v":0},{"$f":"TOOL!D22","v":0},{"$f":"TOOL!E22","v":0}]
[]
["ORDER NUMBER"]
[]
[]
[]
[]
[]
[]
["CLAIM ALREADY SUBMITTED?"]
[]
[null,"Claim paid"]
["Lenses"]
[]
["Frame"]
[]
["Total",{"$f":"TOOL!C35","v":0}]
[]
["PRICE MATCH REFUND?"]
[]
["Refund"]

{"sheet":"TOOL","index":1,"n_rows":47,"n_cols":23,"rows_kept":47,"cut":false,"hidden":true,"merged":[[15,12,15,13],[16,14,16,15],[37,18,37,22],[17,14,17,15],[18,14,18,15],[19,12,20,13],[18,18,18,19],[19,18,23,21],[19,14,20,15],[18,12,18,13],[21,12,23,13],[30,19,30,20],[3,9,3,11],[4,9,4,11],[5,9,5,11],[16,9,16,11],[6,9,6,11],[7,9,7,11],[8,9,8,11],[9,9,9,11],[10,9,10,11],[0,0,0,4],[1,2,1,3],[1,8,2,11],[1,12,2,13],[1,14,2,15],[36,1,36,2],[30,1,30,2],[24,1,26,3],[11,18,11,21],[14,14,14,15],[15,14,15,15],[11,9,11,11],[12,9,12,11],[13,9,13,11],[14,9,14,11],[18,9,18,11],[17,9,17,11],[17,12,17,13],[15,9,15,11],[14,12,14,13],[16,12,16,13]]}
["Glasses - Reimbursement After the Fact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost","Copay","Choice","Signature"]
[null,null,null,null,null,{"$f":"IF(C9=34, \"SV\",IF(C9=49,\"PAL\",\"NAH\"))","v":"NAH"},null,null,"Lens Enhancement Chart",null,null,null,"Choice",null,"Signature",null,null,null,{"$f":"C9*IF(F4,0.9,1)*IF(F5,0.8,1)*IF(F6,0.85,1)","v":0},{"$f":"D9","v":0},{"$f":"T2","v":0},{"$f":"T2","v":0}]
[null,"VSP Plan Type",null,null,null,{"$f":"IF(C3=\"SIGNATURE\",2,IF(C3=\"CHOICE\",1,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C12*IF(F4,0.9,1)*IF(F5,0.8,1)*IF(F6,0.85,1)","v":0},{"$f":"D12","v":0},{"$f":"IF(F5,IF(S3<=T3,S3,T3),IF(S3<=T3,S3*0.8,T3))","v":0},{"$f":"IF(S3<=T3,S3,T3)","v":0}]
[null,"Discounts",false,false,null,{"$f":"C4","v":false},null,null,"CODE","MEANING",null,null,"Single Vision","Progressive","Single Vision","Progressive",null,null,{"$f":"C13*IF(F4,0.9,1)*IF(F5,0.8,1)*IF(F6,0.85,1)","v":0},{"$f":"D13","v":0},{"$f":"IF(F5,IF(S4<=T4,S4,T4),IF(S4<=T4,S4*0.8,T4))","v":0},0]
[null,null,"Original Unit Price","VSP Allowance",null,{"$f":"D4","v":false},null,{"$f":"COUNTIF(B12:B17,\"AD\")","v":0},"AD","Polycarbonate",null,null,31,35,23,28,null,null,{"$f":"C14*IF(F4,0.9,1)*IF(F5,0.8,1)*IF(F6,0.85,1)","v":0},{"$f":"D14","v":0},{"$f":"IF(F5,IF(S5<=T5,S5,T5),IF(S5<=T5,S5*0.8,T5))","v":0},0]
[null,"Frame",null,null,{"$f":"W11","v":0},false,null,{"$f":"COUNTIF(B12:B17,\"AB\")","v":0},"AB","High Index Plastic 1.53-1.60/Trivex",null,null,"80% U&C","80% U&C",51,55,null,null,{"$f":"C15*IF(F4,0.9,1)*IF(F5,0.8,1)*IF(F6,0.85,1)","v":0},0,{"$f":"IF(F5,IF(S6<=T6,S6,T6),IF(S6<=T6,S6*0.8,T6))","v":0},0]
[null,null,null,null,null,null,null,{"$f":"COUNTIF(B12:B17,\"AH\")","v":0},"AH","High Index Plastic 1.66/1.67",null,null,"80% U&C","80% U&C",76,90,null,null,{"$f":"C16*IF(F4,0.9,1)*IF(F5,0.8,1)*IF(F6,0.85,1)","v":0},0,{"$f":"IF(F5,IF(S7<=T7,S7,T7),IF(S7<=T7,S7*0.8,T7))","v":0},0]
[null,null,"Original Unit Price","VSP Material Copay",null,null,null,{"$f":"COUNTIF(B12:B17,\"BV\")","v":0},"BV","UV Protection - Backside",null,null,10,10,10,10,null,null,{"$f":"C17*IF(F4,0.9,1)*IF(F5,0.8,1)*IF(F6,0.85,1)","v":0},0,{"$f":"IF(F5,IF(S8<=T8,S8,T8),IF(S8<=T8,S8*0.8,T8))","v":0},0]
[null,{"$f":"IF(C9=34,\"SINGLE VISION\",IF(C9=49,\"PROGRESSIVE\",\"BASE LENS\"))","v":"BASE LENS"},null,null,{"$f":"S2-T2","v":0},null,null,{"$f":"COUNTIF(B12:B17,\"PP\")","v":0},"PP","Photochromic",null,null,70,82,62,76,null,null,"---->","Totals>",{"$f":"SUM(U2:U8)","v":0},{"$f":"SUM(V2:V8)","v":0}]
[null,null,null,null,null,null,null,{"$f":"COUNTIF(B12:B17,\"QN\")","v":0},"QN","Anti Reflective coating B",null,null,58,58,51,51,null,null,"Cost","Allow","OOP","Discounts","Reimburse"]
[null,null,"Original Unit Price","LE Chart Copay",null,null,null,{"$f":"COUNTIF(B12:B17,\"QV\")","v":0},"QV","Anti Reflective coating D",null,null,85,85,75,75,null,null,{"$f":"C6*IF(F4,0.9,1)*IF(F5,0.8,1)*IF(F6,0.85,1)","v":0},{"$f":"D6","v":0},{"$f":"IF(S11>T11,S11-T11,0)*0.8","v":0},{"$f":"C38+C34","v":0},{"$f":"(S11-U11)-V11","v":0}]
[null,{"$f":"RATF!A15","v":0},null,null,{"$f":"IF(F3=1,S3-U3,S3-V3)","v":0},null,null,{"$f":"COUNTIF(B12:B17,\"DA\")","v":0},"DA","Polarized",null,null,"80% U&C","80% U&C",53,71,null,null,"**Yellow boxes do complicated maths**"]
[null,{"$f":"RATF!A17","v":0},null,null,{"$f":"IF(F3=1,S4-U4,S4-V4)","v":0},null,null,{"$f":"COUNTIF(B12:B17,\"DD\")","v":0},"DD","Polycarbonate",null,null,"80% U&C","80% U&C",27,27]
[null,{"$f":"RATF!A19","v":0},null,null,{"$f":"IF(F3=1,S5-U5,S5-V5)","v":0},null,null,{"$f":"COUNTIF(B12:B17,\"DH\")","v":0},"DH","High Index Plastic 1.66/1.67",null,null,"80% U&C","80% U&C",82,"- -"]
[null,{"$f":"RATF!A21","v":0},null,null,{"$f":"IF(F3=1,S6-U6,S6-V6)","v":0},null,null,{"$f":"COUNTIF(B12:B17,\"KA\")","v":0},"KA","Progressive Standard",null,null,55,null,50,null,null,null,null,null,null,"▼ Lens Sum"]
[null,{"$f":"RATF!A23","v":0},null,null,{"$f":"IF(F3=1,S7-U7,S7-V7)","v":0},null,null,{"$f":"COUNTIF(B12:B17,\"KD\")","v":0},"KD","Polycarbonate",null,null,35,null,30,null,null,null,null,null,null,{"$f":"SUM(E9:E17)","v":0}]
[null,{"$f":"RATF!A25","v":0},null,null,{"$f":"IF(F3=1,S8-U8,S8-V8)","v":0},null,null,{"$f":"COUNTIF(B12:B17,\"KB\")","v":0},"KB","High Index Plastic 1.53-1.60/Trivex",null,null,"80% U&C",null,42]
[null,null,null,null,null,null,null,{"$f":"COUNTIF(B12:B17,\"KH\")","v":0},"KH","High Index Plastic 1.66/1.67",null,null,"80% U&C",null,72]
[null,null,"Retail Cost","With Benefits","Reimbursement",null,null,{"$f":"COUNTIF(B12:B17,\"KP\")","v":0},"KP","Polarized",null,null,"80% U&C",null,76,null,null,null,"◄ Fact Check"]
[null,"Lenses",{"$f":"SUM(S2:S8)","v":0},{"$f":"IF(F3=1,U9,V9)","v":0},{"$f":"IF((OR(C33>=1,V16<=1)),V16-C33, V16)","v":0},null,null,null,null,null,null,null,"LE Chart or 80% of U&C, whichever is less.",null,"No discount on U&C"]
[null,"Frame",{"$f":"C6*IF(F4,0.9,1)*IF(F5,0.8,1)*IF(F6,0.85,1)","v":0},{"$f":"U11","v":0},{"$f":"IF(W11<=0,0,W11)","v":0}]
[null,"Total",{"$f":"SUM(C9:C17,C6)*IF(F4,0.9,1)*IF(F5,0.8,1)*IF(F6,0.85,1)","v":0},{"$f":"D20+D21","v":0},{"$f":"E20+E21","v":0},null,null,null,null,null,null,null,"If \"80% of U&C\" applies, enter the cost in the copay cell as well."]
[]
[null,"Order #"]
[null,{"$f":"IF(E20<=0,\"Eyeconic Order \"&C24&\": Pay \"&TEXT(E22,\"$#,##0.00\")&\" for frame. Bill the difference between in and OON coverage to the client.\",\"Eyeconic Order \"&C24&\": Pay \"&TEXT(E20,\"$#,##0.00\")&\" for lens and \"&TEXT(E21,\"$#,##0.00\")&\" for frame, total \"&TEXT(E22,\"$#,##0.00\")&\". Bill the difference between in and OON coverage to the client.\")","v":"Eyeconic Order : Pay $0.00 for frame. Bill the difference between in and OON coverage to the client."}]
[]
[]
[null,null,"Nathan Arcuri","Updated: 8/5/19"]
[]
[]
[null,"OON Claim already submitted?"]
[null,null,"Claim paid"]
[null,"Lenses"]
[null,"Frame"]
[null,"Total",{"$f":"C33+C34","v":0}]
[]
[null,"Price Match refund already made?"]
[null,"Refund"]
[]
[]
[]
[]
[]
[]
[]
["CHOICE"]
["SIGNATURE"]

{"sheet":".","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,9,18]]}
["PLEASE DO NOT OPEN THIS DOCUMENT IN THE BROWSER. DOWNLOAD THE DOCUMENT OR USE THE LINK PROVIDED BY NATHAN ARCURI IN THE EMAIL."]